--Cach tao VIEW
CREATE VIEW Regions_List_View
AS
SElECT * FROM Regions

GO
-- Cact tao view : 
CREATE PROC Regions_List_GetData
(
	@RegionID int = null
)
AS
SELECT * 
FROM Regions_List_View 
WHERE RegionID = @RegionID

-- Cach Run Store : Store 'Tham so truyen vao'
--vd:
Regions_List_GetData 1
